EMT Practice Test

1. Question Content...

---

Question1: Which one of the following values will appear first if they are sorted in descending order?

Question2: A data analyst is developing a dashboard to track and monitor metrics. Which of the following best practices should be taken into during the FIRST pment process?

Question3: A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out documents and editing them before submissions are considered final. Which of the following is the BEST way to meet this stakeholder requirement?

Question4: Given the following customer and order tables:
Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?

Question5: A data analyst has a set with more than 40.000 rows in the sample schema below:

The analyst would like to create one column that contains the customers' birth dates. Which of the following data quality dimensions would BEST explain the reason for compilation?

Question6: You would like to measure how well an organization is achieving its goals.
What type of analysis should you perform?

Question7: An analyst runs a report on a daily basis, and the number of datapoints must be validated before the data can be analyzed. The number of datapoints increases each day by approximately 20% of the total number from the day before. On a given day, the number of datapoints was 8,798. Which of the following should be the total number of datapoints on the next day?

Question8: A data analyst for a media company needs to determine the most popular movie genre. Given the table below:

Which of the following must be done to the Genre column before this task can be completed?

Question9: When analyzing the values of two variables, you decide to convert both variables so they are on a scale of 0 to 1.
What term describes this action?

Question10: An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step the analyst should take in the dashboard creation process?

Question11: What role in a data governance is typically responsible for day-to-day oversight of data use?

Question12: The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state. Specifically, the director wants to see the following:
* County outages
* Status
* Overall trend of outages
INSTRUCTIONS:
Please, select each visualization to fit the appropriate space on the dashboard and choose an appropriate color scheme. Once you have selected all visualizations, please, select the appropriate titles and labels, if applicable. Titles and labels may be used more than once.
If at any time you would like to bring back the initial state of the simulation, please click the Reset All button.

Question13: Jenny wants to study the academic performance of undergraduate sophomores and wants to determine the average grade point average at different points during an academic year.
What best describes the data set she needs?

Question14: Randy scored 76 on a math test, Katie scored 86 on a science test, Ralph scored 80 on a history test, and Jean scored 80 on an English test. The table below contains the mean and standard deviation of the scores for each of the courses:

Using this information, which of the following students had the BEST score?

Question15: Which of the following is a characteristic of a relational database?

Question16: What R package makes it easy to work with dates?

Question17: Amanda needs to create a dashboard that will draw information from many other data sources and present it to business leaders.
Which one of the following tools is least likely to meet her needs?

Question18: Consider this dataset showing the retirement age of 11 people, in whole years:
54, 54, 54, 55, 56, 57, 57, 58, 58, 60, 60
This tables show a simple frequency distribution of the retirement age data.

Question19: What category of data stewardship work is focused on ensuring that the organization respects the wishes of data subjects?

Question20: Which of the following is a control measure for preventing a data breach?

Question21: A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of:

Question22: A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN:

Customer Table -
In-store Transactions -

Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?

Question23: An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:

Which of the following functions did the analyst use to generate the data in the Sales_indicator column?

Question24: Given the diagram below:

Which of the following data schemas shown?

Question25: What subset of Structured Query Language (SQL) is used to add, remove, modify, or retrieve the information stored within a relational database?

Question26: Alex wants to use data from his corporate sale, CRM, and shipping systems to try and predict future sales.
Which of the following systems is the most appropriate?
Choose the best answer.

Question27: Which of the following is the correct data type for text?

Question28: Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?

Question29: Exhibit.

Which of the following logical statements results in Table B?

Question30: A data analyst needs to create a data visualization that aids in un the cumulative impact of sequentially introduced values that are positive or negative. Which of the following data visualization methods should the analyst use?

Question31: Afinancial institution is reporting on sales performance to a company at the account level. Due to the sensitive nature of the government the does il with, some account information is not shown. Which of the following fields should be masked?

Question32: Daniel is using the structured Query language to work with data stored in relational database.
He would like to add several new rows to a database table.
What command should he use?

Question33: The number of phone calls that call center receives in a day is an example of:

Question34: Given the table below:

Which of the following boxes indicates that a Type Il error has occurred?

Question35: Which of the following data sampling methods involves dividing a population into subgroups by similar characteristics?

Question36: A data analyst wants to create "Income Categories" that would be calculated based on the existing variable "Income". The "Income Categories" would be as follows:
Income category 1: less than $1.
Income category 2: more than $1 and less than $20,000.
Income category 3: more than $20,001 and less than $40,000.
Income category 4: more than $40,001.
Which of the following data manipulation techniques should the data analyst use to create "Income Categories"?

Question37: Given the data below:

In which of the following file formats is the data presented?

Question38: Which of the ing is the correct ion for a tab-delimited spre file?

Question39: A data scientist wants to see which products make the most money and which products attract the most customer purchasing interest in their company.
Which of the following data manipulation techniques would he use to obtain this information?

Question40: Jhon is working on an ELT process that sources data from six different source systems.
Looking at the source data, he finds that data about the sample people exists in two of six systems.
What does he have to make sure he checks for in his ELT process?
Choose the best answer.

Question41: An analyst needs to provide a chart to identify the composition between the categories of the survey response data set:

Which of the following charts would be BEST to use?

Question42: Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?

Question43: You have two databases tables that you would like to join together using a foreign key relationship.
What term best describes this action?

Question44: A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on marketing investment. Which of the following should the data analyst use to BEST communicate this information to the manager?

Question45: A data analyst has been asked to create a sales report that calculates the rolling 12-month average for sales. If the report will be published on November 1, 2020, which of the following months shouts the report cover?

Question46: Which of the following is an example of a data-mining ETL tool?

Question47: A data analyst has been asked to derive a new variable labeled "Promotion_flag" based on the total quantity sold by each salesperson. Given the table below:

Which of the following functions would the analyst consider appropriate to flag "Yes" for every salesperson who has a number above 1,000,000 in the Quantity_sold column?

Question48: A data analyst must separate the column shown below into multiple columns for each component of the name:

Which of the following data manipulation techniques should the analyst perform?

Question49: Given the following data tables:

Which of the following MDM processes needs to take place FIRST?

Question50: A data analyst was asked to create a chart that shows the relationship between study hours and exam scores for each student using the data sets in the table below:

Which of the following charts would BEST represent the relationship between the variables?

Question51: The process of performing initial investigations on data to spot outliers, discover patterns, and test assumptions with statistical insight and graphical visualization is called:

Question52: You should always choose the analytics tool that is most appropriate for any given situation, even if that means acquiring a new tool.

Question53: Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?

Question54: A data analyst has been asked to organize the table below in the following ways:
By sales from high to low -
By state in alphabetic order -

Which of the following functions will allow the data analyst to organize the table in this manner?

Question55: An analysts building a monthly report for production and wants to ensure the audience is aware of its once-a-month cadence. Which of the following is the MOST important to convey that information?

Question56: Which one of the following in NOT a common data integration tool?

Question57: Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?

Question58: You are working with a dataset and need to swap the values in rows with those in columns.
What action do you need to perform?

Question59: Which of the following contains alphanumeric values?

Question60: Which of the following is an example of a at flat file?

Question61: What SQL command is used to delete an entire table from a database?

Question62: Which of the following would be considered non-personally identifiable information?

Question63: Angela is aggregating data from CRM system with data from an employee system.
While performing an initial quality check, she realizes that her employee ID is not associated with her identifier in the CRM system.
What kind of issues is Angela facing?
Choose the best answer.

Question64: 'Which of the following is the BEST reason to use database views instead of tables?

Question65: Five dogs have the following heights in millimeters:
300, 430, 170, 470, 600
Which of the following is the mean height for the five dogs?

Question66: You are working with a dataset and want to change the names of categories that you used for different types of books.
What term best describes this action?

Question67: A sales team wants visibility of current sales numbers, pipeline, and team performance. The team would also like to see calculations of individuals' earned commissions and projected commissions based on sales, but they want that information to be kept confidential. Which of the following would be the BEST way to provide this visibility?

Question68: The ACME Corporation hired an analyst to detect data quality issues in their excel documents. Which of the following are the most common issues? (Select TWO)

Question69: What would be an example of an acceptable form of primary identification for the Data+ exam?

Question70: Given the following data:

Which of the following BEST describes the data set?

Question71: A data analyst is asked to create a sales report for the second-quarter 2020 board meeting, which will include a review of the business's performance through the second quarter. The board meeting will be held on July 15, 2020, after the numbers are finalized. Which of the following report types should the data analyst create?